﻿CREATE TABLE DBDictionary.DBCurrencyPrice
(
	ID									uniqueidentifier PRIMARY KEY,		/* Identifier */
	DBDictionaryID						uniqueidentifier NOT NULL,			/* Dictionary this rate is linked to */
	ForeignCurrency						varchar(3) NOT NULL,				/* ISO code of the ForeignCurrency */
	CurrencyPrice						float NOT NULL,						/* Rate that applies between "ForeignCurrency" and global "DomesticCurrency" */ 
	
	FOREIGN KEY(DBDictionaryID)	REFERENCES DBDictionary.DBDictionary(ID) ON DELETE CASCADE,
			
	UNIQUE(DBDictionaryID,ForeignCurrency),

	_InsertionStamp							bigint,
	_UpdateStamp							bigint,
);
